Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA11800
Product: Project Accounting (258)
Series:
Display Name: PA Combined History Header file Group Display Name: PA Combined History
Physical Name: PA11800
Technical Name: PA_Combined_History_WORK_HDR
Group Technical Name: PA Combined History
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | PATU  | PA Transaction Usage | Integer | PA_DDL_Transaction_Usage | 0 | |
| 2 | PADocnumber20 | PA Document No. | String | STR17_LBAU | 17 | |
| 3 | PATRXType | PA TRX Type | Integer | PA_DDL_TRX_Type | 0 | |
| 4 | PADOCDT | PA Document Date | Date | PA_Date | 8 | |
| 5 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PA Combined History Header file'].USERID AS 'PA Combined History Header file-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Combined History Header file'].USERID = ['Users Master'].USERID | ||||||
| 6 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 7 | PAREFNO | PA Reference Document No. | String | STR17_LBAU | 17 | |
| 8 | PAUD1 | PA User Defined 1 | String | STR20 | 20 | |
| 9 | PAUD2 | PA User Defined 2 | String | STR20 | 20 | |
| 10 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['PA Combined History Header file'].VENDORID AS 'PA Combined History Header file-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA Combined History Header file'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 11 | PACOSTOWNER | PA Cost Owner | String | STR30_Item_Number | 30 | |
| 12 | PAREPD | PA Reporting Period | Integer | INT3 | 3 | |
| 13 | PAREPDT | PA Reporting Date | Date | PA_Date | 8 | |
| 14 | PAreptsuff | PA Reporting Suffix | String | PA_STR5 | 5 | |
| 15 | PAYR | PA Year | Integer | INT4 | 4 | |
| 16 | PAVENINVNO | PA Vendor Invoice Number | String | STR20_Document_Number | 20 | |
| 17 | PAVENADDRESSID | PA Vendor Address ID | String | STR15_Address_Code | 15 | |
| 18 | PACOMM | PA Comment | String | STR50 | 50 | |
| 19 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['PA Combined History Header file'].PYMTRMID AS 'PA Combined History Header file-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PA Combined History Header file'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
| 20 | DUEDATE | Due Date | Date | DT | 8 | |
| 21 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 22 | DISCDATE | Discount Date | Date | DT | 8 | |
| 23 | DISAMTAV | Discount Amount Available | Currency | DLR17_RBS0_UTR$ | 17 | |
| 24 | PRCTDISC | Percent Discount | Integer | INT5_%2 | 5 | |
| 25 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA Combined History Header file'].CURNCYID AS 'PA Combined History Header file-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Combined History Header file'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 26 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['PA Combined History Header file'].SHIPMTHD AS 'PA Combined History Header file-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PA Combined History Header file'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 27 | PATQTY | PA Total Quantity | Currency | DLR17_QTY_RBS0_UTR | 17 | |
| 28 | PAtotcosts | PA Total Costs | Currency | PA_DLR17_RBS0_STR$ | 17 | |
| 29 | BKTPURAM | Backout Purchases Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 30 | PATACRV | PA Total Accrued Revenues | Currency | DLR17_RBS0_UTR$ | 17 | |
| 31 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | PAFreight_Taxable_P | PA Freight Taxable - Purchase | Integer | PA_DDL_Tax_Options_Purchase | 0 | |
| 33 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Combined History Header file'].FRTSCHID AS 'PA Combined History Header file-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Combined History Header file'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 34 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 35 | FRTTXAMT | Freight Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 36 | PAMisc_Taxable_P | PA Misc Taxable - Purchase | Integer | PA_DDL_Tax_Options_Purchase | 0 | |
| 37 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Combined History Header file'].MSCSCHID AS 'PA Combined History Header file-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Combined History Header file'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 38 | MSCCHAMT | Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 39 | MSCTXAMT | Misc Tax Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 40 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 41 | DOCAMNT | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 42 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | UN1099AM | Unapplied 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 44 | CASHAMNT | Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 45 | CAMCBKID | Cash Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PA Combined History Header file'].CAMCBKID AS 'PA Combined History Header file-Cash Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PA Combined History Header file'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 46 | CDOCNMBR | Cash Document Number | String | STR20_Document_Number | 20 | |
| 47 | CAMTDATE | Cash Amount Date | Date | DT | 8 | |
| 48 | CAMPMTNM | Cash Amount Payment Number | String | STR20_LBAU | 20 | |
| 49 | CHEKAMNT | Check Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 50 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 51 | CHEKDATE | Check Date | Date | DATE | 6 | |
| 52 | CAMPYNBR | Check Amount Payment Number | String | STR20_LBAU | 20 | |
| 53 | CHAMCBID | Check Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['PA Combined History Header file'].CHAMCBID AS 'PA Combined History Header file-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['PA Combined History Header file'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 54 | CRCRDAMT | Credit Card Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 55 | CARDNAME | Card Name | String | STR15_Card_Name | 15 | |
| 56 | CRCARDDT | Credit Card Date | Date | DATE | 6 | |
| 57 | CCAMPYNM | Credit Card Amount Payment Number | String | STR20_LBAU | 20 | |
| 58 | CCRCTNUM | Credit Card Receipt Number | String | STR20_Document_Number | 20 | |
| 59 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 60 | CHRGAMNT | Charge Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 61 | LNITMSEQ | Line Item Sequence | Long Integer | LI_Sequence_Number | 10 | |
| 62 | PAPD | PA Post Date | Date | PA_Date | 8 | |
| 63 | VOIDSTTS | Void Status | Integer | INT | 0 | |
| 64 | VOIDDATE | Void Date | Date | DT | 8 | |
| 65 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PA Combined History Header file'].NOTEINDX AS 'PA Combined History Header file-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA Combined History Header file'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 66 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['PA Combined History Header file'].RATETPID AS 'PA Combined History Header file-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PA Combined History Header file'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
| 67 | EXGTBLID | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['PA Combined History Header file'].EXGTBLID AS 'PA Combined History Header file-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PA Combined History Header file'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
| 68 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 69 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
| 70 | TIME1 | Time | Time | TM6 | 6 | |
| 71 | RTCLCMTD | Rate Calculation Method | Integer | GB | 0 | |
| 72 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 73 | PAORIGTOTCOSTS | PA Originating Total Costs | Currency | DLR17_RBS0_UTR$ | 17 | |
| 74 | PAORIACCRREV | PA Originating Accrued Revenues | Currency | DLR17_RBS0_UTR$ | 17 | |
| 75 | DISAVAMT | Discount Available Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 76 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Combined History Header file'].TAXSCHID AS 'PA Combined History Header file-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA11800 AS ['PA Combined History Header file']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Combined History Header file'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 77 | PYMNTTRM | Payment Terms | String | Payment_Term | 15 | |
| 78 | POPTYPE | POP Type | Integer | DDL_POP_Type | 0 | |
| 79 | VNDDOCNM | Vendor Document Number | String | STR20_Document_Number | 20 | |
| 80 | ACTLSHIP | Actual Ship Date | Date | DT | 8 | |
| 81 | GLPOSTDT | GL Posting Date | Date | DT | 8 | |
| 82 | DSCPCTAM | Discount Percent Amount | Integer | INT5_%2 | 5 | |
| 83 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 84 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |