| CUSTNMBR | char(15) | Yes | Customer Number | IN |
| HOLD | tinyint | No | Hold Status: 0=Not On Hold; 1=On Hold; Default=0 on new record | IN |
| INACTIVE | tinyint | No | Inactive: 0=Active; 1=Inactive; Default=0 on new record | IN |
| CUSTNAME | char(64) | No | Customer Name | IN |
| SHRTNAME | char(15) | No | Short Name; Default=@I_vCUSTNAME if not passed in | IN |
| STMTNAME | char(64) | No | Statement Name; Default=@I_vCUSTNAME if not passed in | IN |
| CUSTCLAS | char(15) | No | Class ID | IN |
| CUSTPRIORITY | smallint | No | Priority; valid values 1 (none) to 100; Default=1 on new record | IN |
| ADRSCODE | char(15) | No | Primary Address ID | IN |
| CNTCPRSN | char(60) | No | Contact | IN |
| ADDRESS1 | char(60) | No | Address1 | IN |
| ADDRESS2 | char(60) | No | Address2 | IN |
| ADDRESS3 | char(60) | No | Address3 | IN |
| CITY | char(35) | No | City | IN |
| STATE | char(29) | No | State | IN |
| ZIPCODE | char(10) | No | Zip | IN |
| CCode | char(6) | No | Country Code | IN |
| COUNTRY | char(60) | No | Country | IN |
| PHNUMBR1 | char(21) | No | Phone 1 | IN |
| PHNUMBR2 | char(21) | No | Phone 2 | IN |
| PHNUMBR3 | char(21) | No | Phone 3 | IN |
| FAX | char(21) | No | Fax | IN |
| UPSZONE | char(3) | No | UPS Zone | IN |
| SHIPMTHD | char(15) | No | Shipping Method | IN |
| TAXSCHID | char(15) | No | Tax Schedule | IN |
| SHIPCOMPLETE | tinyint | No | Ship Complete Documents: 0=False; 1=True; Default=0 on new record | IN |
| PRSTADCD | char(15) | No | Ship To Address Code | IN |
| PRBTADCD | char(15) | No | Bill To Address Code | IN |
| STADDRCD | char(15) | No | Statement To Address Code | IN |
| SLPRSNID | char(15) | No | Salesperson ID | IN |
| SALSTERR | char(15) | No | Sales Territory | IN |
| USERDEF1 | char(20) | No | User-Defined 1 | IN |
| USERDEF2 | char(20) | No | User-Defined 2 | IN |
| COMMENT1 | char(30) | No | Comment 1 | IN |
| COMMENT2 | char(30) | No | Comment 2 | IN |
| CUSTDISC | numeric(19,5) | No | Trade Discount | IN |
| PYMTRMID | char(20) | No | Payment Terms | IN |
| DISGRPER | smallint | No | Discount Grace Period | IN |
| DUEGRPER | smallint | No | Due Date Grace Period | IN |
| PRCLEVEL | char(10) | No | Price Level | IN |
| NOTETEXT | varchar(8000) | No | Note Text | IN |
| BALNCTYP | tinyint | No | Balance Type: 0=Open Item 1=Balance Forward; Default=0 on new record | IN |
| FNCHATYP | smallint | No | Finance Charge Type: 0=None; 1=Percent; 2=Amount; Default=0 for new record | IN |
| FNCHPCNT | numeric(19,5) | No | Finance Charge Percent: Used if @I_vFNCHATYP=1 | IN |
| FINCHDLR | numeric(19,5) | No | Finance Charge Dollar: Used if @I_vFNCHATYP=2 | IN |
| MINPYTYP | smallint | No | Minimum Payment Type: 0=No Minimum; 1=Percent; 2=Amount; Default=0 for new record | IN |
| MINPYPCT | numeric(19,5) | No | Minimum Payment Percent: Used if @I_vMINPYTYP=1 | IN |
| MINPYDLR | numeric(19,5) | No | Minimum Payment Dollar Amount: Used if @I_vMINPYTYP=2 | IN |
| CRLMTTYP | smallint | No | Credit Limit Type: 0=No Credit; 1=Unlimited; 2=Amount; Default=0 on new record | IN |
| CRLMTAMT | numeric(19,5) | No | Credit Limit Amount: Used if @I_vCRLMTTYP=2 | IN |
| CRLMTPER | smallint | No | Credit Limit Period: Used if @I_vCRLMTTYP=2 and the Credit Limit Warning in GP is used | IN |
| CRLMTPAM | numeric(19,5) | No | Credit Limit Period Amount: Used if @I_vCRLMTTYP=2 and Credit Limit Warning in GP is used | IN |
| MXWOFTYP | smallint | No | Maximum Writeoff Type: 0=Not Allowed; 1=Unlimited; 2=Maximum; Default=0 for new record | IN |
| MXWROFAM | numeric(19,5) | No | Maximum Writeoff Amount: Used if @I_vMXWOFTYP=2 | IN |
| Revalue_Customer | tinyint | No | Revalue Customer: 0=Do Not Revalue; 1=Revalue; Default=1 for new record | IN |
| Post_Results_To | smallint | No | Post Results To: 0=Rec./Discount Acct; 1=Sales Offset Acct; Default=0 on new record | IN |
| ORDERFULFILLDEFAULT | tinyint | No | Order Fulfillment Shortage: 1=None; 2=Back Order Remaining; 3=Cancel Remaining; Default=1 on new record | IN |
| INCLUDEINDP | tinyint | No | Include In Demand Planning: 0=Do Not Include; 1=Include; Default=1 on new record | IN |
| CRCARDID | char(15) | No | Credit Card ID | IN |
| CRCRDNUM | char(20) | No | Credit Card Number | IN |
| CCRDXPDT | datetime | No | Credit Card Expiration Date | IN |
| BANKNAME | char(30) | No | Bank Name | IN |
| BNKBRNCH | char(20) | No | Bank Branch | IN |
| USERLANG | smallint | No | User Language; Default=0 on new record | IN |
| TAXEXMT1 | char(25) | No | Tax Exempt 1 | IN |
| TAXEXMT2 | char(25) | No | Tax Exempt 2 | IN |
| TXRGNNUM | char(25) | No | Tax Registration | IN |
| CURNCYID | char(15) | No | Currency ID | IN |
| RATETPID | char(15) | No | Rate Type ID | IN |
| STMTCYCL | smallint | No | Statement Cycle: 1=No Statement; 2=Weekly; 3=Biweekly; 4=Semimonthly; 5=Monthly; 6=Bimonthly; 7=Quarterly | IN |
| KPCALHST | tinyint | No | Maintain History - Calendar Year: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record | IN |
| KPERHIST | tinyint | No | Maintain History - Fiscal Year: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record | IN |
| KPTRXHST | tinyint | No | Maintain History - Transaction: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record | IN |
| KPDSTHST | tinyint | No | Maintain History - Distribution: 0=Do Not Maintain History; 1=Maintain History; Default=1 on new record | IN |
| Send_Email_Statements | tinyint | No | Send E-mail Statements: 0=Do Not Send Statements; 1=Send Statements; Default=0 on new record | IN |
| ToEmail_Recipient | char(80) | No | To... E-mail Recipient: Separate each recipient with a ";" | IN |
| CcEmail_Recipient | char(80) | No | Cc... E-mail Recipient: Separate each recipient with a ";" | IN |
| BccEmail_Recipient | char(80) | No | Bcc... E-mail Recipient: Separate each recipient with a ";" | IN |
| CHEKBKID | char(15) | No | Check Book ID | IN |
| DEFCACTY | smallint | No | Cash Account From: 0=Checkbook; 1=Customer; Default=0 on new record | IN |
| RMCSHACTNUMST | varchar(75) | No | Cash Account: Only valid if @I_vDEFCACTY=1 | IN |
| RMARACTNUMST | varchar(75) | No | Accounts Receivable Account | IN |
| RMSLSACTNUMST | varchar(75) | No | Sales Account | IN |
| RMCOSACTNUMST | varchar(75) | No | Cost Of Sales Account | IN |
| RMIVACTNUMST | varchar(75) | No | Inventory Account | IN |
| RMTAKACTNUMST | varchar(75) | No | Terms Discount Taken Account | IN |
| RMAVACTNUMST | varchar(75) | No | Terms Discount Available Account | IN |
| RMFCGACTNUMST | varchar(75) | No | Finance Charges Account | IN |
| RMWRACTNUMST | varchar(75) | No | Writeoffs Account | IN |
| RMSORACTNUMST | varchar(75) | No | Sales Order Returns Account | IN |
| RMOvrpymtWrtoffACTNUMST | varchar(75) | No | Overpayment Writeoffs Account | IN |
| GPSFOINTEGRATIONID | char(30) | No | Front Office Integration ID | IN |
| INTEGRATIONSOURCE | smallint | No | Integration Source | IN |
| INTEGRATIONID | char(30) | No | Integration ID | IN |
| UseCustomerClass | tinyint | No | Flag to have class setting roll down to parameters that are not passed in. Uses the @I_vCUSTCLAS class | IN |
| CreateAddress | tinyint | No | Flag to allow a primary address code to be created on the fly: 0=Do not create address; 1=create address | IN |
| UpdateIfExists | tinyint | No | Flag to allow updates: 0=Create only; 1=Update if exists; 2=Create, do NOT update(no error) | IN |
| RequesterTrx | smallint | No | Requester Transaction: 0=False; 1=True - if true than populates Requester shadow table | IN |
| USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
| USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
| USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
| ErrorState | int | No | Create Custom Business Logic | INOUT |
| oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |