Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA33100
Product: Project Accounting (258)
Series: Project
Display Name: PA Billing Header HIST Group Display Name: PA Billing Transactions History
Physical Name: PA33100
Technical Name: PA_Billing_HDR_HIST
Group Technical Name: PA Billing Transactions History
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | SQL DB Length | Keyable Length |
---|---|---|---|---|---|---|
1 | PABILLTRXT ![]() | PA Biller Trx Type | PA_DDL_Biller_Trx_Type | Integer | 2 | 0 |
2 | PADocnumber20 ![]() | PA Document No. | STR17_LBAU | String | 18 | 17 |
3 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 10 | 14 |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['PA Billing Header HIST'].NOTEINDX AS 'PA Billing Header HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA Billing Header HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
4 | PADOCDT ![]() | PA Document Date | PA_Date | Date | 4 | 8 |
5 | PAPD ![]() | PA Post Date | PA_Date | Date | 4 | 8 |
6 | BACHNUMB ![]() | Batch Number | STR15_LBAU | String | 16 | 15 |
7 | BCHSOURC ![]() | Batch Source | STR15 | String | 16 | 15 |
8 | TRXSORCE ![]() | TRX Source | STR13 | String | 14 | 13 |
9 | PAuserid ![]() | PA User ID | STR15_User_ID | String | 16 | 15 |
10 | LSTEDTDT ![]() | Last Edit Date | DT_Date | Date | 4 | 6 |
11 | LSTUSRED ![]() | Last User to Edit | STR15 | String | 16 | 15 |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['PA Billing Header HIST'].LSTUSRED AS 'PA Billing Header HIST-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PA Billing Header HIST'].LSTUSRED = ['Users Master'].USERID | ||||||
12 | PAREFNO ![]() | PA Reference Document No. | STR17_LBAU | String | 18 | 17 |
13 | CUSTNMBR ![]() | Customer Number | STR15_RM_Customer_Number | String | 16 | 15 |
Key to the RM Customer MSTR (RM00101).
Click to show/hideSELECT
['PA Billing Header HIST'].CUSTNMBR AS 'PA Billing Header HIST-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['PA Billing Header HIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR | ||||||
14 | CSTPONBR ![]() | Customer PO Number | STR20_Document_Number | String | 22 | 20 |
15 | PRBTADCD ![]() | Primary Billto Address Code | STR15_LBAU | String | 16 | 15 |
16 | PYMTRMID ![]() | Payment Terms ID | STR20_Payment_Terms_ID | String | 22 | 20 |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['PA Billing Header HIST'].PYMTRMID AS 'PA Billing Header HIST-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['PA Billing Header HIST'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
17 | PABILLFORMAT ![]() | PA Bill Format | STR15_LBAU | String | 16 | 15 |
18 | PACOMM ![]() | PA Comment | STR50 | String | 52 | 50 |
19 | CURNCYID ![]() | Currency ID | STR15_Currency_ID | String | 16 | 15 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA Billing Header HIST'].CURNCYID AS 'PA Billing Header HIST-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Billing Header HIST'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
20 | PAUD1 ![]() | PA User Defined 1 | STR20 | String | 22 | 20 |
21 | PAUD2 ![]() | PA User Defined 2 | STR20 | String | 22 | 20 |
22 | CASHAMNT ![]() | Cash Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
23 | CBKIDCSH ![]() | Checkbook ID Cash | STR15_Checkbook_ID | String | 16 | 15 |
24 | CASHDATE ![]() | Cash Date | DATE | Date | 4 | 6 |
25 | DCNUMCSH ![]() | Document Number Cash | STR20_Document_Number | String | 22 | 20 |
26 | CHEKAMNT ![]() | Check Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
27 | CBKIDCHK ![]() | Checkbook ID Check | STR15_Checkbook_ID | String | 16 | 15 |
28 | CHEKNMBR ![]() | Check Number | STR20_Document_Number | String | 22 | 20 |
29 | CHEKDATE ![]() | Check Date | DATE | Date | 4 | 6 |
30 | DCNUMCHK ![]() | Document Number Check | STR20_Document_Number | String | 22 | 20 |
31 | CRCRDAMT ![]() | Credit Card Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
32 | CRCRDNAM ![]() | Credit Card Name | STR15 | String | 16 | 15 |
33 | RCTNCCRD ![]() | Receipt Number Credit Card | STR20_Document_Number | String | 22 | 20 |
34 | CRCARDDT ![]() | Credit Card Date | DATE | Date | 4 | 6 |
35 | DCNUMCRD ![]() | Document Number Credit Card | STR20_Document_Number | String | 22 | 20 |
36 | DSCPCTAM ![]() | Discount Percent Amount | INT5_%2 | Integer | 2 | 5 |
37 | DSCDLRAM ![]() | Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 10 | 11 |
38 | DISAVAMT ![]() | Discount Available Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
39 | DISCAMNT ![]() | Discount Amount | DLR17_RBS0_STR$ | Currency | 10 | 17 |
40 | DISCDATE ![]() | Discount Date | DT | Date | 4 | 8 |
41 | DISTKNAM ![]() | Discount Taken Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
42 | DISCRTND ![]() | Discount Returned | DLR17_RBS0_STR$ | Currency | 10 | 17 |
43 | PABillingAmount ![]() | PA Billing Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
44 | TRDISAMT ![]() | Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
45 | PA_Freight_Amount ![]() | PA Freight Amount | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
46 | PA_Misc_Amount ![]() | PA Misc Amount | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
47 | FRTTXAMT ![]() | Freight Tax Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
48 | MSCTXAMT ![]() | Misc Tax Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
49 | PATOTTAX ![]() | PA Total Tax | DLR15_RBU$2 | Currency | 10 | 15 |
50 | PABACKBILL ![]() | PA Backout Bill Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
51 | BKTFRTAM ![]() | Backout Freight Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
52 | BKTMSCAM ![]() | Backout Misc Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
53 | DOCAMNT ![]() | Document Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
54 | DUEDATE ![]() | Due Date | DT | Date | 4 | 8 |
55 | APPLDAMT ![]() | Applied Amount | DLR17_RBS0_STR$ | Currency | 10 | 17 |
56 | PALastDateApplied ![]() | PA Last Date Applied | DATE | Date | 4 | 6 |
57 | SLPRSNID ![]() | Salesperson ID | STR15_Salesperson_ID | String | 16 | 15 |
Key to the RM Salesperson Master (RM00301).
Click to show/hideSELECT
['PA Billing Header HIST'].SLPRSNID AS 'PA Billing Header HIST-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['PA Billing Header HIST'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID | ||||||
58 | SALSTERR ![]() | Sales Territory | STR15_Sales_Territory | String | 16 | 15 |
Key to the Sales Territory Master File (RM00303).
Click to show/hideSELECT
['PA Billing Header HIST'].SALSTERR AS 'PA Billing Header HIST-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['PA Billing Header HIST'].SALSTERR = ['Sales Territory Master File'].SALSTERR | ||||||
59 | TAXSCHID ![]() | Tax Schedule ID | STR15_Tax_Schedule_ID | String | 16 | 15 |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Billing Header HIST'].TAXSCHID AS 'PA Billing Header HIST-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Billing Header HIST'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
60 | COMDLRAM ![]() | Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
61 | COMAPPTO ![]() | Commission Applied To | GB | Integer | 2 | 0 |
62 | LNITMSEQ ![]() | Line Item Sequence | LI_Sequence_Number | Long Integer | 4 | 10 |
63 | CUTOFDAT ![]() | Cutoff Date | DT | Date | 4 | 8 |
64 | SHIPMTHD ![]() | Shipping Method | STR15_Shipping_Method | String | 16 | 15 |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['PA Billing Header HIST'].SHIPMTHD AS 'PA Billing Header HIST-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['PA Billing Header HIST'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
65 | MSCSCHID ![]() | Misc Schedule ID | STR15_LBAU | String | 16 | 15 |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Billing Header HIST'].MSCSCHID AS 'PA Billing Header HIST-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Billing Header HIST'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
66 | MISCTXBL ![]() | Misc Taxable | DDL_Tax_Options | Integer | 2 | 0 |
67 | FRTSCHID ![]() | Freight Schedule ID | STR15_LBAU | String | 16 | 15 |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['PA Billing Header HIST'].FRTSCHID AS 'PA Billing Header HIST-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['PA Billing Header HIST'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
68 | FRGTTXBL ![]() | Freight Taxable | DDL_Tax_Options | Integer | 2 | 0 |
69 | PARetentionFeeAmount ![]() | PA Retention Fee Amount | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
70 | PARetainer_Fee_Amount ![]() | PA Retainer Fee Amount | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
71 | PAtotbillings ![]() | PA Total Billings | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
72 | PAlastprtby ![]() | PA Last Printed By | STR15_User_ID | String | 16 | 15 |
73 | PAlastprtdate ![]() | PA Last Printed Date | DATE | Date | 4 | 6 |
74 | ORCASAMT ![]() | Originating Cash Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
75 | ORCHKAMT ![]() | Originating Check Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
76 | ORCCDAMT ![]() | Originating Credit Card Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
77 | ORDDLRAT ![]() | Originating Discount Dollar Amount | DLR11_RBS0_UTR$ | Currency | 10 | 11 |
78 | ORDAVAMT ![]() | Originating Discount Available Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
79 | ORTDISAM ![]() | Originating Trade Discount Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
80 | ORFRTTAX ![]() | Originating Freight Tax Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
81 | ORMSCTAX ![]() | Originating Misc Tax Amount | DLR19_RBSO_UTR$ | Currency | 10 | 19 |
82 | ORBKTFRT ![]() | Originating Backout Freight Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
83 | ORBKTMSC ![]() | Originating Backout Misc Amount | DLR19_RBS0_UTR$ | Currency | 10 | 19 |
84 | ORDOCAMT ![]() | Originating Document Amount | DLR17_RBS0_STR$ | Currency | 10 | 17 |
85 | ORAPPAMT ![]() | Originating Applied Amount | DLR17_RBS0_STR$ | Currency | 10 | 17 |
86 | ORCOMAMT ![]() | Originating Commission Dollar Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
87 | PAOrigBillAmount ![]() | PA Originating Billing Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
88 | PAOrigFreightAmt ![]() | PA Originating Freight Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
89 | PAOrigMiscAmt ![]() | PA Originating Misc Amount | DLR17_RBSO_STR$ | Currency | 10 | 17 |
90 | PAOrigTotalTaxAmt ![]() | PA Originating Total Tax | DLR17_RBSO_STR$ | Currency | 10 | 17 |
91 | PAOrigBackoutBillAmt ![]() | PA Originating Backout Bill Amt | DLR17_RBS0_STR$ | Currency | 10 | 17 |
92 | PAOrigRetentionFeeAmt ![]() | PA Originating Retention Fee Amt | DLR17_RBS0_STR$ | Currency | 10 | 17 |
93 | PAOrigRetainerFeeAmt ![]() | PA Originating Retainer Fee Amt | DLR17_RBS0_STR$ | Currency | 10 | 17 |
94 | PAOrigTotalBilings ![]() | PA Originating Total Billings | DLR17_RBS0_STR$ | Currency | 10 | 17 |
95 | PAOrigDiscTakenAmt ![]() | PA Originating Discount Taken Amt | DLR17_RBS0_STR$ | Currency | 10 | 17 |
96 | PAOrigDiscRetAmt ![]() | PA Originating Discount Returned Amt | DLR17_RBS0_STR$ | Currency | 10 | 17 |
97 | CURRNIDX ![]() | Currency Index | INT3 | Integer | 2 | 3 |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['PA Billing Header HIST'].CURRNIDX AS 'PA Billing Header HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PA Billing Header HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
98 | RATETPID ![]() | Rate Type ID | STR15_Rate_Type_ID | String | 16 | 15 |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['PA Billing Header HIST'].RATETPID AS 'PA Billing Header HIST-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PA Billing Header HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
99 | EXGTBLID ![]() | Exchange Table ID | STR15_Exchange_Table_ID | String | 16 | 15 |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['PA Billing Header HIST'].EXGTBLID AS 'PA Billing Header HIST-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PA33100 AS ['PA Billing Header HIST']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PA Billing Header HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
100 | XCHGRATE ![]() | Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
101 | EXCHDATE ![]() | Exchange Date | DT_Date | Date | 4 | 6 |
102 | TIME1 ![]() | Time | TM6 | Time | 4 | 6 |
103 | RTCLCMTD ![]() | Rate Calculation Method | GB | Integer | 2 | 0 |
104 | DENXRATE ![]() | Denomination Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 10 | 14 |
105 | MCTRXSTT ![]() | MC Transaction State | INT1 | Integer | 2 | 1 |
106 | PAPostoDynRM ![]() | PA Post to Dyn Receivables Mgmt | PA_CB_Post_RM | Boolean | 2 | 0 |
107 | Tax_Date ![]() | Tax Date | DT | Date | 4 | 8 |
108 | PA_Third_Party_CB ![]() | PA Third Party CB | CB | Boolean | 2 | 0 |
109 | BCKTXAMT ![]() | Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
110 | OBTAXAMT ![]() | Originating Backout Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
111 | BackoutTradeDiscTax ![]() | Backout Trade Discount Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
112 | OrigBackoutTradeDiscTax ![]() | Originating Backout Trade Discount Tax Amount | DLR17_RBS0_UTR$ | Currency | 10 | 17 |
113 | PA_Backout_Retention_Tax ![]() | PA Backout Retention Tax Amount | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
114 | PA_OrigBackRetentionTax ![]() | PA Originating Backout Retention Tax Amount | PA_DLR17_RBS0_STR$ | Currency | 10 | 17 |
115 | DEX_ROW_ID ![]() | int | int | 10 | 10 | |
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |