|
  
|
||
|
|
||
The Transaction Headers table contains the all Transaction Details except for the lines which are stored in the Transaction Lines table.
Relational Links
The Transaction Headers are linked relationally to their Transaction Lines records using the idxFolio field which is in both databases. For each Transaction Header record there can be zero or more Transaction Line Records.
Field Name |
Description |
Type |
Length |
thRunNo |
Posting Run Number |
Integer |
4 |
thAcCode |
Account Code |
Lstring |
11 |
idxAcCode |
Account Code |
String |
6 |
thAutoNom |
|
Logical |
1 |
thOurRef |
Our Ref |
Lstring |
11 |
thIdxDocCode |
|
String |
1 |
idxOurRef |
Our Ref |
String |
10 |
thFolio |
Folio Number |
Integer |
4 |
idxFolio |
Folio Number (index) |
Integer |
4 |
thCurrency |
Currency |
Integer |
1 |
thYear |
Year 2 Digit |
Integer |
1 |
thIdxYearPeriod |
|
String |
2 |
thPeriod |
Period |
Integer |
1 |
thDueDate |
Due Date |
Date |
8 |
thIdxDueDate |
Due Date |
Date |
8 |
thVATDate |
VAT Date |
Date |
8 |
thIdxVATDate |
VAT Date |
Date |
8 |
thTransDate |
Transaction Date |
Date |
8 |
thIdxTransDate |
Transaction Date |
Date |
8 |
thCustSupp |
C/S |
String |
1 |
idxAcType |
Account Type |
String |
1 |
thCompanyRate |
Company Rate |
Float |
|
thDailyRate |
Daily Rate |
Float |
2 |
thOLDYourRef |
Your Reference (No longer used) |
String |
10 |
thIdxOLDYourRef |
Your Reference (No longer used) |
String |
10 |
thBatchLink |
Batch Entry Link |
String |
12 |
thIdxBatchLink |
Batch Entry Link |
String |
12 |
thAllocStat |
Allocated Status |
String |
1 |
thDocType |
Transaction type |
Integer |
1 |
thVAT_Standard |
VAT Amount (S) |
Float |
|
thVAT_Exempt |
VAT Amount (E) |
Float |
|
thVAT_Zero |
VAT Amount (Z) |
Float |
|
thVAT_Rate1 |
VAT Amount (1) |
Float |
|
thVAT_Rate2 |
VAT Amount (2) |
Float |
|
thVAT_Rate3 |
VAT Amount (3) |
Float |
|
thVAT_Rate4 |
VAT Amount (4) |
Float |
|
thVAT_Rate5 |
VAT Amount (5) |
Float |
|
thVAT_Rate6 |
VAT Amount (6) |
Float |
|
thVAT_Rate7 |
VAT Amount (7) |
Float |
|
thVAT_Rate8 |
VAT Amount (8) |
Float |
|
thVAT_Rate9 |
VAT Amount (9) |
Float |
|
thVAT_RateT |
VAT Amount (T) |
Float |
|
thVAT_RateX |
VAT Amount (X) |
Float |
|
thVATRate_B |
VAT Amount (B) |
Float |
|
thVATRate_C |
VAT Amount (C) |
Float |
|
thVATRate_F |
VAT Amount (F) |
Float |
|
thVATRate_G |
VAT Amount (G) |
Float |
|
thVATRate_R |
VAT Amount (R) |
Float |
|
thVATRate_W |
VAT Amount (W) |
Float |
|
thVATRate_Y |
VAT Amount (Y) |
Float |
|
thNetValue |
Net Value |
Float |
|
thTotalVAT |
Total VAT |
Float |
|
thSettlePerc |
Settlement Percentage |
Float |
|
thTotSettleDisc |
Total Settlement Discount |
Float |
|
thTotLineDisc |
Total Line Discount1 |
Float |
|
thDiscDays |
Discount Days |
Integer |
2 |
thDiscTaken |
Settlement Discount Taken Y/N |
Logical |
1 |
thSettled |
Amount Settled |
Float |
|
thAutoIncUnit |
|
Integer |
2 |
thAutoYear |
|
Integer |
1 |
thAutoPeriod |
|
Integer |
1 |
thSSDTransNat |
Intrastat Transport Nature |
Integer |
1 |
thSSDTransMode |
Intrastat Transport Mode |
Integer |
1 |
thRemitRef |
|
Lstring |
11 |
thAutoUnits |
|
String |
1 |
thHold |
Hold Status |
Integer |
1 |
thTotalWeight |
Total Weight |
Float |
|
thDelAddr1 |
Delivery Address Line 1 |
Lstring |
31 |
thDelAddr2 |
Delivery Address Line 2 |
Lstring |
31 |
thDelAddr3 |
Delivery Address Line 3 |
Lstring |
31 |
thDelAddr4 |
Delivery Address Line 4 |
Lstring |
31 |
thDelAddr5 |
Delivery Address Line 5 |
Lstring |
31 |
thCurrVar |
|
Float |
|
thTotal1 |
|
Float |
|
thTotal2 |
|
Float |
|
thTotalCost |
|
Float |
|
thTotalInvoiced |
|
Float |
|
thYourRefLong |
Alt Your Reference |
Float |
20 |
thIdxYourRefLong |
Alt Your Reference |
String |
20 |
thAutoUntil |
Auto Daybook "repeat until" |
Date |
8 |
thExternal |
External Transaction Flag |
Logical |
1 |
thPrinted |
Printed Flag |
Logical |
1 |
thCurrVariance |
|
Float |
|
thAmtSettled |
|
Float |
|
thSettledVAT |
|
Float |
|
thVATClaimed |
|
Float |
|
thBatchPayGL |
|
Integer |
4 |
thAutoPost |
|
Logical |
1 |
thManualVAT |
Manual VAT Flag |
Logical |
1 |
thSSDDelTerms |
In Loc Transfer on ADJ |
Lstring |
4 |
thUser |
|
Lstring |
11 |
thNoLabels |
Number of Labels |
Integer |
2 |
thTagged |
Tagged (Y/N) |
Logical |
1 |
thPickRunNo |
Pick Run Number |
Integer |
4 |
thOrderMatch |
|
Logical |
1 |
thDelivNote |
|
Lstring |
11 |
thVATCompRate |
VAT Company Rate |
Float |
|
thVATDailyRate |
VAT Daily Rate |
Float |
|
thOrigCompRate |
Original Company Rate |
Float |
|
thOrigDailyRate |
Original Daily Rate |
Float |
|
thPostDiscAmt |
Posted Discount Amount |
Float |
|
thPostDiscTaken |
Posted Discount Taken Flag |
Logical |
1 |
thDrCrGL |
|
Integer |
4 |
thJobCode |
Job Code |
Lstring |
11 |
thJobAnal |
Analysis Code |
Lstring |
11 |
thOutstOrder |
|
Integer |
2 |
thOutstOrder_2 |
|
Integer |
4 |
thUser1 |
User Defined Field 1 |
Lstring |
31 |
thUser2 |
User Defined Field 2 |
Lstring |
31 |
thLineType1 |
Transaction Line Type 1 Total |
Float |
8 |
thLineType2 |
Transaction Line Type 2 Total |
Float |
8 |
thLineType3 |
Transaction Line Type 3 Total |
Float |
8 |
thLineType4 |
Transaction Line Type 4 Total |
Float |
8 |
thLineType5 |
Transaction Line Type 5 Total |
Float |
8 |
thLineType6 |
Transaction Line Type 6 Total |
Float |
8 |
thDebtChaseNo |
Debt Chase Letter Number |
Integer |
1 |
thBatOwnSettl |
|
Float |
8 |
thBatPaySettl |
|
Float |
8 |
thBatUntagged |
|
Logical |
1 |
thUser3 |
User Defined Field 3 |
Lstring |
31 |
thUser4 |
User Defined Field 4 |
Lstring |
31 |
thProcess |
|
String |
1 |
thSource |
|
Integer |
1 |
thMainTriRate |
|
Float |
8 |
thMainTriEuro |
|
Integer |
1 |
thMainTriInvert |
|
Logical |
1 |
thMainTriFloat |
|
Logical |
1 |
thMainTriSpare |
|
String |
10 |
thVATTriRate |
|
Float |
8 |
thVATTriEuro |
|
Integer |
1 |
thVATTriInvert |
|
Logical |
1 |
thVATTriFloat |
|
Logical |
1 |
thVATTriSpare |
|
String |
10 |
thOrigTriRate |
|
Float |
8 |
thOrigTriEuro |
|
Integer |
1 |
thOrigTriInvert |
|
Logical |
1 |
thOrigTriFloat |
|
Logical |
1 |
thOrigTriSpare |
|
String |
10 |
thPreEuroTriRate |
|
Float |
8 |
thPreEuroTriEuro |
|
Integer |
1 |
thPreEuroTriInvert |
|
Logical |
1 |
thPreEuroTriFloat |
|
Logical |
1 |
thPreEuroTriSpare |
|
String |
10 |
thPostDate |
Date Posted |
Date |
8 |
thPORPickSOR |
|
Logical |
1 |
thBatchDiscAmount |
|
Float |
8 |
thPrePost |
|
Integer |
1 |
thAuthorisedAmount |
|
Float |
8 |
thTimeChanged |
|
Lstring |
7 |
thTimeCreated |
|
Lstring |
7 |
thCISTaxDue |
CIS Tax Due |
Float |
8 |
thCISTaxDeclared |
CIS Tax declared on Voucher |
Float |
8 |
thCISManualTax |
CIS Manual Tax |
Logical |
1 |
thCISDate |
CIS Date |
Date |
8 |
thTotalCostApport |
|
Float |
8 |
thCISEmployee |
CIS Employee code |
Lstring |
11 |
thCISTotalGross |
CIS Gross Total |
Float |
8 |
thCISSource |
CIS Source |
Integer |
1 |
thExported |
Exported Flag |
Logical |
1 |
thCISGrossExclude |
|
Float |
8 |
thSpare |
Future Use |
String |
64 |
thYourRefLB |
Not Used |
String |
1 |
thYourRef |
Your Reference (v6.00) |
String |
20 |
thIdxYourRef |
Your Reference (v6.00) |
String |
20 |
thSpare3 |
Future Use |
String |
255 |
thSpare4 |
Future Use |
String |
255 |
thSpare5 |
Future Use |
String |
255 |
thSpare6 |
Future Use |
String |
35 |
